I. Official website descriptionWhen we built the DBCA, we were prompted to choose the connection type, there are two types: Dedicated server mode and shared server mode. Private mode is used by default. Such as:The Oracle official documentation
Shared Server under Oracle 9i (multi-thread Server MTS in 8i) It is mainly used in OLTP services. It takes only a short time for a server process to process the business, and most of them are in idle State. In this case, fewer resources can be used,
In a shared server architecture, a dispatcher dispatcher directs multiple session requests for incoming networks to a shared server process pool, eliminating the need to assign a dedicated server process to each connection. As a general guideline,
In a shared server architecture, a dispatcher dispatcher directs multiple session requests for incoming networks to a shared server process pool, eliminating the need to assign a dedicated server process to each connection. As a general guideline,
One, the shared server mode work mechanism:
Shared server mode (also known as the MTS Multi-threaded server):
After the database is started, there are two more processes than the dedicated server mode, one is the dispatch process (dispatcher)
[From: http://bbs.51testing.com/thread-173827-1-4.html]
I. Shared Server mode.
The Shared Server mode is also called the multi-thread server mode. In this mode, the Oracle database allows multiple user processes to share very few server processes.
The Shared Server SharedServer under Oracle9i (the multi-thread server MTS in 8i) is mainly used in the OLTP business, and each server process needs to process the business very short.
The Shared Server under Oracle 9i (the multi-thread Server MTS
Refreshing ing Oracle Database for Shared Server (updating)
When the database is in the form of a shared server, client requests and database connections are divided into the following steps:
1) connect the client request to the database, listen to
There are two main ways for users to connect to the Oracle database server: private server connection and shared server connection. In the private server mode, when the client sends a connection request to the database
There are two main ways for
There are two main ways for users to connect to the oracle database server: private server connection and shared server connection.
In VPC mode, when the client sends a request to connect to the database, the listener is responsible for connecting
The Oracle dedicated server and the Shared Server connect to the Oracle server to process requests. These two methods are dedicated server connection and shared server connection. Dedicated server www.2cto.com: Oracle will always create a new thread
Oracle Shared Server Configuration
1. Exclusive server (dedicatedserver)
Each session is assigned a serverprocess independently. Resources occupied by the process are released only when the user disconnects. In most cases, sessions are idle, so
When creating an Oracle database, you should see this option in the database creation assistant wizard, which is the connection mode of the database. In Oracle9i or 10g, we can see two connection modes: a dedicated server connection (dedicated
When creating an Oracle database, you should see this option in the database creation assistant wizard, which is the connection mode of the database. In Oracle9i or 10g, we can see two connection modes: a dedicated server connection (dedicated
When creating an Oracle database, you should see this option in the database creation assistant wizard, which is the connection mode of the database. In Oracle9i or 10g, we can see two connection modes: a dedicated server connection (dedicated
How to enable the Oracle Shared Server has unique advantages in some applications, as shown in the official description: reduce the number of instance processes, increase the number of external service users, reduce the number of useless or idle
After the oracle Shared Server is created successfully, the number of jdbc connections is limited. The following error occurs: java. SQL. SQLException: I/O SOLUTION error Description: After configuring the Shared Server for oracle, there is no
Parameters related to shared serverSHARED_SERVERS: Specifies the initial number of shared servers to start and the minimum number of shared servers to keep. This is the only required parameter for using shared servers.
MAX_SHARED_SERVERS: Specifies
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.